insert overwrite table jms_dim.dim_lmdm_threecode_analysis_detail
select
collect_time
,bill_source_name
,bill_no
,agent_code
,receiver_city_name
,receiver_address
,terminal_code
,sign_three_segement_code
,exception_code
,exception_name
,pick_network_name
,customer_name
,sign_network_name
,dispatch_staff_name
,sign_time
,agent_name
from jms_ods.yl_cn_lmdm_threecode_analysis_detail where dt = '{{ execution_date | cst_ds }}'
 distribute by 1 ;